<?php
header('Content-type:text/html;charset=utf-8');

//包含数据库配置
include '../../public/peizhi.php';

//包含函数
include '../../public/func.php';

//调用函数
$link = db();

//设置时区
date_default_timezone_set('PRC');
?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>主要内容区main</title>
<link href="css/css.css" type="text/css" rel="stylesheet" />
<link href="css/main.css" type="text/css" rel="stylesheet" />
<link rel="shortcut icon" href="images/main/favicon.ico" />
<style>
body{overflow-x:hidden; background:#f2f0f5; padding:15px 0px 10px 5px;}
#searchmain{ font-size:12px;}
#search{ font-size:12px; background:#548fc9; margin:10px 10px 0 0; display:inline; width:100%; color:#FFF; float:left}
#search form span{height:40px; line-height:40px; padding:0 0px 0 10px; float:left;}
#search form input.text-word{height:24px; line-height:24px; width:180px; margin:8px 0 6px 0; padding:0 0px 0 10px; float:left; border:1px solid #FFF;}
#search form input.text-but{height:24px; line-height:24px; width:55px; background:url(images/main/list_input.jpg) no-repeat left top; border:none; cursor:pointer; font-family:"Microsoft YaHei","Tahoma","Arial",'宋体'; color:#666; float:left; margin:8px 0 0 6px; display:inline;}
#search a.add{ background:url(images/main/add.jpg) no-repeat -3px 7px #548fc9; padding:0 10px 0 26px; height:40px; line-height:40px; font-size:14px; font-weight:bold; color:#FFF; float:right}
#search a:hover.add{ text-decoration:underline; color:#d2e9ff;}
#main-tab{ border:1px solid #eaeaea; background:#FFF; font-size:12px;}
#main-tab th{ font-size:12px; background:url(images/main/list_bg.jpg) repeat-x; height:32px; line-height:32px;}
#main-tab td{ font-size:12px; line-height:40px;}
#main-tab td a{ font-size:12px; color:#548fc9;}
#main-tab td a:hover{color:#565656; text-decoration:underline;}
.bordertop{ border-top:1px solid #ebebeb}
.borderright{ border-right:1px solid #ebebeb}
.borderbottom{ border-bottom:1px solid #ebebeb}
.borderleft{ border-left:1px solid #ebebeb}
.gray{ color:#dbdbdb;}
td.fenye{ padding:10px 0 0 0; text-align:right;}
.bggray{ background:#f9f9f9}
</style>
</head>
<body>
<!--main_top-->
<table width="99%" border="0" cellspacing="0" cellpadding="0" id="searchmain">
  <tr>
    <td width="99%" align="left" valign="top">您的位置：主贴管理</td>
  </tr>
  <tr>
    <td align="left" valign="top">
    <table width="100%" border="0" cellspacing="0" cellpadding="0" id="search">
  		<tr>
   		 <td width="90%" align="left" valign="middle">
	         <form method="get" action="show.php">
				 <span>主贴名称：</span>
				 <input type="text" name="u_name" value="" class="text-word">
				 <span>主贴ID：</span>
				 <input type="text" name="u_id" value="" class="text-word">
				 <input name="sub" type="submit" value="查询" class="text-but">
	         </form>
         </td>
  		  <!--<td width="10%" align="center" valign="middle" style="text-align:right; width:150px;"><a href="add.php" target="mainFrame" onFocus="this.blur()" class="add">新增分区</a></td>-->
  		</tr>
	</table>
    </td>
  </tr>
  <tr>
    <td align="left" valign="top">
    <form method="post" action="del.php">
    <table width="100%" border="0" cellspacing="0" cellpadding="0" id="main-tab">
      <tr>
	  	<th align="center" valign="middle" class="borderright">主贴序号</th>
		<th align="center" valign="middle" class="borderright">主贴ID</th>
		<th align="center" valign="middle" class="borderright">板块名字</th>
        <th align="center" valign="middle" class="borderright">发帖用户</th>
		<th align="center" valign="middle" class="borderright">主贴标题</th>
		<th align="center" valign="middle" class="borderright">主贴内容</th>
		<th align="center" valign="middle" class="borderright">发帖时间</th>
        <th align="center" valign="middle">操作</th>
      </tr>
<?php
	  //判断是否有查询操作
		if(!empty($_GET['u_name'])){
			$u_name = $_GET['u_name'];
			$wherearr[] = " title like '%{$u_name}%'";
			$duo[] = "title={$u_name}";
		}else{
			$wherearr = '';
			$where = '';
			$duo = '';
		}
				
		if(!empty($_GET['u_id'])){
			$u_id = $_GET['u_id'];
			$wherearr[] = " id={$u_id}";
			$duo[] = "id={$u_id}";
		}
		
		if(is_array($wherearr)){
			$where = 'and'.implode('and',$wherearr);
			$duo = '&'.implode('&',$duo);
		}	

	  //分页
	  //当前页
	  $current = isset($_GET['page']) ? $_GET['page'] : 1 ;
	  
	  //每页条数
	  $row = 2;
	  
	  //第几页
	  $page = ($current - 1) * $row;
	  
	  $limit = "limit {$page},{$row}";
	  
	  //计算帖子总数
	  $sumsql = "select count(*) from fatie where huishou=2";
	  
	  //执行SQL语句
	  $sumres = mysqli_query($link,$sumsql);

	  //获取结果 总数
	  if($sumres && mysqli_num_rows($sumres)){
		$sum = mysqli_fetch_row($sumres);
		mysqli_free_result($sumres);
		$rows = $sum[0];
	  }
	  
	  //计算总页数
	  $sumpage = ceil($rows / $row);
	  
	  //判断上一页
	  $prev = $current - 1 ;
	  if($prev < 1){
		$prev = 1;
	  }

	  //判断下一页
	  $next = $current + 1 ;
	  if($next >= $sumpage){
		$next = $sumpage;
	  }
	
	  //准备SQL语句
	  $sql = "select b.bk_id,b.bk_name,f.id,f.u_name,f.huishou,f.title,f.content,f.ft_time from fatie f,bankuai b where f.bk_id=b.bk_id and huishou=2 {$where} {$limit}";

	  //执行SQL语句
	  $res = mysqli_query($link,$sql);

	  //判断并获取结果
	  $i = isset($_GET['xuhao']) ? $_GET['xuhao'] : 1;
		  if($res && mysqli_num_rows($res)){
			while($result = mysqli_fetch_assoc($res)){
?>
      <tr onMouseOut="this.style.backgroundColor='#ffffff'" onMouseOver="this.style.backgroundColor='#edf5ff'">
	    <td align="center" valign="middle" class="borderright borderbottom"><?php echo $i;$i++;?></td>
		<td align="center" valign="middle" class="borderright borderbottom"><input type="checkbox" name="tz_id[]" value="<?php echo $result['id'];?>"><?php echo $result['id'];?></td>
		<td align="center" valign="middle" class="borderright borderbottom"><?php echo $result['bk_name'];?></td>
		<td align="center" valign="middle" class="borderright borderbottom"><?php echo $result['u_name'];?></td>
		<td align="center" valign="middle" class="borderright borderbottom"><?php echo $result['title'];?></td>
		<td align="center" valign="middle" class="borderright borderbottom"><?php echo $result['content'];?></td>
		<td align="center" valign="middle" class="borderright borderbottom"><?php echo date('Y-m-d H:i:s',$result['ft_time']);?></td>
        <td align="center" valign="middle" class="borderbottom">
			<a href="return.php?tz_id=<?php echo $result['id'];?>" target="mainFrame" onFocus="this.blur()" class="add">还原</a><span class="gray">&nbsp;|&nbsp;</span>
			<a href="del.php?tz_id=<?php echo $result['id'];?>" target="mainFrame" onFocus="this.blur()" class="add">删除</a>
		</td>
      </tr>
<?php		
			}
		}

?>
    </table>
	<input type="submit" name="pldel" value="批量删除">
	</form>
	</td>
    </tr>
<?php
		//判断上一页序号
		$p_i = ($current - 2) * $row + 1;
		if($p_i < 1){
			$p_i = 1;
		}

		//判断下一页序号
		$n_i = $i;
		if($n_i > $rows){
			$n_i = ($sumpage - 1) * $row + 1;
		}

		//判断尾页序号
		$end_i = ($sumpage - 1) * $row + 1;
	
		//释放结果
		mysqli_free_result($res);

		
		//关闭数据库连接
		mysqli_close($link);
?>
  <tr>
    <td align="left" valign="top" class="fenye"><?php echo $rows;?> 条数据 &nbsp;&nbsp;第<?php echo $current;?>页 / 共<?php echo $sumpage;?> 页&nbsp;&nbsp;
		<a href="huishou.php?page=1<?php echo $duo;?>&xuhao=1" target="mainFrame" onFocus="this.blur()">首页</a>&nbsp;&nbsp;
		<a href="huishou.php?page=<?php echo $prev.$duo;?>&xuhao=<?php echo $p_i;?>" target="mainFrame" onFocus="this.blur()">上一页</a>&nbsp;&nbsp;
		<a href="huishou.php?page=<?php echo $next.$duo;?>&xuhao=<?php echo $n_i;?>" target="mainFrame" onFocus="this.blur()">下一页</a>&nbsp;&nbsp;
		<a href="huishou.php?page=<?php echo $sumpage.$duo;?>&xuhao=<?php echo $end_i;?>" target="mainFrame" onFocus="this.blur()">尾页</a>
	</td>
  </tr>
</table>
</body>
</html>